# -*-coding:utf8
import os
import pandas as pd
from public.common.globalconfig import data_path


class Data(object):
    '''
    测试数据读取
    '''
    @staticmethod
    def get_data():                           # 读取指定列测试数据存入列表
        df = pd.read_excel(os.path.join(data_path, 'Data.xlsx'),
                           usecols=[0], names=None)  # 读取项目名称列,不要列名
        df_li = df.values.tolist()
        result = []
        for s_li in df_li:
            result.append(str(s_li[0]).replace('nan', ''))
        return result

if __name__ == '__main__':

    print(Data.get_data())
